CREATE DATABASE LINQDEMO
GO
USE LINQDEMO
GO
CREATE TABLE Account
(
	Username nvarchar(30) PRIMARY KEY,
	[Password] nvarchar(30),
	Fullname nvarchar(50),
	[Address] nvarchar(50)
)
GO

CREATE TABLE UserInformation
(
	Id int IDENTITY(1,1) PRIMARY KEY,
	Username nvarchar(30),
	Fullname nvarchar(50),
	Gender nvarchar(10),
	Email nvarchar(30),
	Phone nvarchar(15)
)
GO
INSERT INTO UserInformation(Username,Fullname,Gender,Email,Phone) VALUES ('Giza','Dinh Tuan Long','male','longdt@gmail.com','0123456789')
INSERT INTO UserInformation(Username,Fullname,Gender,Email,Phone) VALUES ('Giza','Dinh Tuan Long','male','longdt@gmail.com','0123456789')
INSERT INTO UserInformation(Username,Fullname,Gender,Email,Phone) VALUES ('Giza','Dinh Tuan Long','male','longdt@gmail.com','0123456789')
INSERT INTO UserInformation(Username,Fullname,Gender,Email,Phone) VALUES ('Giza','Dinh Tuan Long','male','longdt@gmail.com','0123456789')
INSERT INTO UserInformation(Username,Fullname,Gender,Email,Phone) VALUES ('Giza','Dinh Tuan Long','male','longdt@gmail.com','0123456789')
INSERT INTO UserInformation(Username,Fullname,Gender,Email,Phone) VALUES ('Giza','Dinh Tuan Long','male','longdt@gmail.com','0123456789')
INSERT INTO UserInformation(Username,Fullname,Gender,Email,Phone) VALUES ('Giza','Dinh Tuan Long','male','longdt@gmail.com','0123456789')
INSERT INTO UserInformation(Username,Fullname,Gender,Email,Phone) VALUES ('Giza','Dinh Tuan Long','male','longdt@gmail.com','0123456789')
INSERT INTO UserInformation(Username,Fullname,Gender,Email,Phone) VALUES ('Giza','Dinh Tuan Long','male','longdt@gmail.com','0123456789')
INSERT INTO UserInformation(Username,Fullname,Gender,Email,Phone) VALUES ('Giza','Dinh Tuan Long','male','longdt@gmail.com','0123456789')
INSERT INTO UserInformation(Username,Fullname,Gender,Email,Phone) VALUES ('Giza','Dinh Tuan Long','male','longdt@gmail.com','0123456789')
GO
select *from UserInformation